The following example sets the tick length and style for the y axis on a chart.
Private Sub Command1_Click()
' Set the tick for y axis.
With Form1.MSChart1.Plot.Axis(VtChAxisIdY, 1).Tick
.Length = 500
.Style = VtChAxisTickStyleOutside
End With
End Sub